
from lib.papyDB import papyDB , tableInfo

papyDB = papyDB()

PROJECT = tableInfo('PROJECT')
SEQUENCES = tableInfo('SEQUENCES')
SHOT = tableInfo('SHOT')

USER_INFO = tableInfo('USER_INFO')
USER_MACHINE = tableInfo('USER_MACHINE')
DEPARTMENT = tableInfo('DEPARTMENT')
TOOLS_INFO = tableInfo('TOOLS_INFO')

PROJECT_has_ASSET = tableInfo('PROJECT_has_ASSET')
SEQUENCES_has_ASSET = tableInfo('SEQUENCES_has_ASSET')
SHOT_has_ASSET = tableInfo('SHOT_has_ASSET')

ASSET = tableInfo('ASSET')
ASSET_VERSION = tableInfo('ASSET_VERSION')
ASSET_COMMENT = tableInfo('ASSET_COMMENT')
ASSET_QT = tableInfo('ASSET_QT')
#ASSET_TAG = tableInfo('ASSET_TAG')
ASSET_has_ASSET_TAG = tableInfo('ASSET_has_ASSET_TAG')

JOB_INFO = tableInfo('JOB_INFO')
JOB_VERSION = tableInfo('JOB_VERSION')
JOB_CMMNT = tableInfo('JOB_CMMNT')
#JOB_QT = tableInfo('JOB_QT')
JOB_ASSEMBLE = tableInfo('JOB_ASSEMBLE')

#RENDER = tableInfo('RENDER')
#RENDER_PASS = tableInfo('RENDER_PASS')
#RENDER_PASS_VERSION = tableInfo('RENDER_PASS_VERSION')
#
#COMP = tableInfo('COMP')
#COMP_VERSION = tableInfo('COMP_VERSION')
#COMP_CMMNT = tableInfo('COMP_CMMNT')
#COMP_QT = tableInfo('COMP_QT')

ASSET_JOB = tableInfo('ASSET_JOB')
ASSET_JOB_VERSION = tableInfo('ASSET_JOB_VERSION')
ASSET_JOB_CMMT = tableInfo('ASSET_JOB_CMMT')
#ASSET_JOB_QT = tableInfo('ASSET_JOB_QT')
ASSET_JOB_ASSEMBLE = tableInfo('ASSET_JOB_ASSEMBLE')


if __name__ =='__main__':
    pass
#    print ASSET.search( 'assetStatus' , 'assetName', assetID = 11 )